Import numbers are rounding

helms1016  wrote:  ``Does the same if I just import it directly as an excel document.``

Not sure what that means; how that is different from ``import a report from our membership software online``.  But I presume that both describe methods of opening a CSV file directly with Excel.

To expand on Martin's suggestion....

Instead, save the CSV file.   You might have to change some brower options in order for it to offer the option to "save" instead of "open with application".

Then start Excel by clicking an Excel icon, not a file icon.

In Excel, import the CSV file by clicking Data > Get External Data > From Text.  That opens the Import Text File wizard.

In the first dialog box, select Delimited, then click Next.  In the second dialog box, unselect Tab (default) and select Comma.  Be sure that "treat consecutive delimiters as one" is unselected (default).  Then click Next.

The "magic" occurs in the third dialog box.  Select the column with membership IDs, and select Text under "column data format".  Repeat for any other columns that should be treated as text, but Excel might interpret as numbers.  Then click Finish.