Skip to main content
Solved

Reagarding maximum Size of Excel which can be import manually easily

  • March 30, 2023
  • 3 replies
  • 209 views

abhilashsawla
Master Author
Forum|alt.badge.img+7

Asking just for knowledge,

What maximum size of excel can we import manually in transaction List?

If our excel size is more than required size than what solution is available in Pigment.

Best answer by Julien

Hi @abhilashsawla, thanks for your question!

The recommendation is to keep files below a few hundred megabytes, if possible below 500 MB.

It is technically possible to upload larger files, though there is a risk it will timeout either during upload or when Pigment is processing them.

There will soon be an explicit limit on file upload which will be documented as soon as it’s enforced.

To workaround this limit, the recommendation is to split very large files into 2 or more smaller files. This will ensure the import remains fast and efficient.

3 replies

abhilashsawla
Master Author
Forum|alt.badge.img+7
  • Author
  • Master Author
  • 104 replies
  • April 3, 2023

Awaiting for answer


Julien
Employee
Forum|alt.badge.img+8
  • Employee
  • 45 replies
  • Answer
  • April 5, 2023

Hi @abhilashsawla, thanks for your question!

The recommendation is to keep files below a few hundred megabytes, if possible below 500 MB.

It is technically possible to upload larger files, though there is a risk it will timeout either during upload or when Pigment is processing them.

There will soon be an explicit limit on file upload which will be documented as soon as it’s enforced.

To workaround this limit, the recommendation is to split very large files into 2 or more smaller files. This will ensure the import remains fast and efficient.


abhilashsawla
Master Author
Forum|alt.badge.img+7
  • Author
  • Master Author
  • 104 replies
  • April 5, 2023

Thanks @Julien