Frequently Asked Questions

  ADA/508 friendly site


How do I import an ASCII delimited file into a spreadsheet?

The procedure to import an ASCII delimited file varies from application to application.  To determine the exact procedure for your application, search your Help section on "import" and "delimited."

Many applications will follow the below procedure:

  1. Make sure the file you want to import ends in ".PRN", ".TXT" or ".CSV".
  2. Select "File," then "Open." 
  3. Change the "Files of Type" menu to "Text Files (*.prn; *.txt; *.csv)."
  4. Point the application to your file.
  5. Click "Next."
  6. Select the delimiters in your file. These are the characters that tell the spreadsheet where a column starts and stops. Most delimited files use commas as delimiters.
  7. Click "Next."
  8. Format the columns as appropriate.
  9. Click "Next."

Your file should now be visible in the spreadsheet.  Consult your application's Help section for more specifics on your situation.


Was this answer helpful?