Versions Compared

Old Version 1

changes.mady.by.user Karen Kohn (Unlicensed)

Saved on

compared with

New Version 2

changes.mady.by.user Karen Kohn (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Export the data to csv, but do not open the file.
  2. Change the extension on the file to .txt.
  3. Open Excel.
  4. Go to File > Open, and find the .txt file. Excel will automatically start the Import Wizard.
  5. Select Delimited, click Next.
  6. Select Comma as the delimiter. Click Next.
  7. Highlight the column that has the ID in it. In the top left corner of the wizard, select Text as the data format.
  8. Click Finish.

Limits to Report Length

There is a limit to how many rows of a report can be exported to Excel. According to this page, the limit for a CSV file should be 500,000. Observation on 2/23/18 shows the limit seems to be 499,801.